﻿CREATE TABLE [dbo].[SemnaturiListe] (
    [IDLista]     SMALLINT NOT NULL,
    [IDSemnatura] SMALLINT NOT NULL,
    [TipLista]    SMALLINT NOT NULL,
    CONSTRAINT [PK_SemnaturiListe] PRIMARY KEY CLUSTERED ([IDLista] ASC, [IDSemnatura] ASC, [TipLista] ASC),
    CONSTRAINT [FK_admin_Liste_Semnaturi] FOREIGN KEY ([IDLista]) REFERENCES [dbo].[admin_Liste] ([IDLista]),
    CONSTRAINT [FK_SemnaturiListe_Semnaturi] FOREIGN KEY ([IDSemnatura]) REFERENCES [dbo].[Semnaturi] ([IdSemnatura])
);

